Tabela BarCodeFlashcard

Definicja tabeli BarCodeFlashcard

Name

BarCodeFlashcard

Code

BarCodeFlashcard

Comment

Tabela bedaca slownikiem wszystkich mozliwych kodów kreskowych zarejestrowanych w systemie.



Lista kolumn tabeli BarCodeFlashcard

Name

Code

BarCodeFlashcardID

BarCodeFlashcardID

StockID

StockID

StockItemID

StockItemID

PackageID

PackageID

BarCode

BarCode

UnitsCount

UnitsCount


Kolumna BarCodeFlashcardID tabeli BarCodeFlashcard

Definicja kolumny BarCodeFlashcardID tabeli BarCodeFlashcard

Name

BarCodeFlashcardID

Code

BarCodeFlashcardID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockID tabeli BarCodeFlashcard

Definicja kolumny StockID tabeli BarCodeFlashcard

Name

StockID

Code

StockID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockItemID tabeli BarCodeFlashcard

Definicja kolumny StockItemID tabeli BarCodeFlashcard

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID asortymentu


Kolumna PackageID tabeli BarCodeFlashcard

Definicja kolumny PackageID tabeli BarCodeFlashcard

Name

PackageID

Code

PackageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BarCode tabeli BarCodeFlashcard

Definicja kolumny BarCode tabeli BarCodeFlashcard

Name

BarCode

Code

BarCode

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Kod kreskowy


Kolumna UnitsCount tabeli BarCodeFlashcard

Definicja kolumny UnitsCount tabeli BarCodeFlashcard

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(12,4)

Mandatory

Yes

Comment

Ilosc leku na fiszce.


Lista kluczy tabeli BarCodeFlashcard

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli BarCodeFlashcard

Definicja klucza Identifier_1 tabeli BarCodeFlashcard

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment